<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-15">
<style>
      .table {
        background-color:#F5F5FF;
        border-left:4px solid gray;
        border-bottom:4px solid gray;
        border-top:4px solid gray;
        border-right:4px solid gray;
        margin-bottom:3em;
        margin-left:2em;
        margin-right:2em;
        padding:1em;
      }
      .tableNameHeading h1 {
          display: inline;
        font-family: Segoe UI, Arial, sans-serif;
        font-size:125%;
        font-weight:bold;
      }
        
      .tableNameHeading h2 {
        display: inline;
        font-family: Segoe UI, Arial, sans-serif;
        font-size:115%;
        font-weight:normal;
      }
      
      .tableComment { 
        background-color:#e4efff; margin-bottom:20px;
      }
      
      .tableDefinition { 
        padding:2px;
        border-collapse:collapse;
        margin-top:1em;
      }

      .tdTableDefinition {
        padding-right:10px;
        vertical-align:top;
        border-top:1px solid #C0C0C0;
      }

      .tdLogicalColName {
        width:20em;
      }
      
      .tdPhysicalColName {
        width:20em;
      }
      
      .tdDataType {
        width:10em;
      }

      .tdPkFlag {
        width:4em;
      }

      .tdNullFlag {
        width:9em;
      }

      .tdTableHeading {
        padding:2px;
        font-family: Segoe UI, Arial, sans-serif;
        font-weight: bold;
        vertical-align:top;
        border-bottom: 1px solid #C0C0C0;
        background-color: rgb(240,240,240);
      }
      
      .subTitle {
        font-family: Segoe UI, Arial, sans-serif;
        font-weight: bold;
      }

      .references {
      }
      .comment {
        color:#666666;
        margin-left:3em;
        padding:0.25em;
      }
    </style>
<title>er_logic</title>
</head>
<body>
<center>
<h2>er_logic</h2>
</center>
<h3>List of tables</h3>
<ul>
<li>
<a href="#BRANCH_DIMENSION">BRANCH_DIMENSION</a>
</li>
<li>
<a href="#CUSTOMER_DIMENSION">CUSTOMER_DIMENSION</a>
</li>
<li>
<a href="#DATE_DIMENSION">DATE_DIMENSION</a>
</li>
<li>
<a href="#EMPLOYEE_DIMENSION">EMPLOYEE_DIMENSION</a>
</li>
<li>
<a href="#PRODUCT_DIMENSION">PRODUCT_DIMENSION</a>
</li>
<li>
<a href="#PROMOTION_DIMENSION">PROMOTION_DIMENSION</a>
</li>
<li>
<a href="#SALES_FACT">SALES_FACT</a>
</li>
<li>
<a href="#SUPPLIER_DIMENSION">SUPPLIER_DIMENSION</a>
</li>
</ul>
<div class="tableNameHeading">
<h1>BRANCH_DIMENSION<a name="BRANCH_DIMENSION"></a>
</h1>
<h2>
      (Physical Name: BRANCH_DIMENSION)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">BRANCH_ID (PK)</td><td class="tdTableDefinition">BRANCH_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_NUMBER</td><td class="tdTableDefinition">LOCATION_NUMBER</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_STREET</td><td class="tdTableDefinition">LOCATION_STREET</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_CITY</td><td class="tdTableDefinition">LOCATION_CITY</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_STATE</td><td class="tdTableDefinition">LOCATION_STATE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_POSTCODE</td><td class="tdTableDefinition">LOCATION_POSTCODE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_COUNTRY</td><td class="tdTableDefinition">LOCATION_COUNTRY</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_PHONE</td><td class="tdTableDefinition">CONTACT_PHONE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_FAX</td><td class="tdTableDefinition">CONTACT_FAX</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_EMAIL</td><td class="tdTableDefinition">CONTACT_EMAIL</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
</table>
<div class="references">
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (BRANCH_ID)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>CUSTOMER_DIMENSION<a name="CUSTOMER_DIMENSION"></a>
</h1>
<h2>
      (Physical Name: CUSTOMER_DIMENSION)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CUSTOMER_ID (PK)</td><td class="tdTableDefinition">CUSTOMER_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_NUMBER</td><td class="tdTableDefinition">LOCATION_NUMBER</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_STREET</td><td class="tdTableDefinition">LOCATION_STREET</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_CITY</td><td class="tdTableDefinition">LOCATION_CITY</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_STATE</td><td class="tdTableDefinition">LOCATION_STATE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_POSTCODE</td><td class="tdTableDefinition">LOCATION_POSTCODE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_COUNTRY</td><td class="tdTableDefinition">LOCATION_COUNTRY</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_PHONE</td><td class="tdTableDefinition">CONTACT_PHONE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_FAX</td><td class="tdTableDefinition">CONTACT_FAX</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_EMAIL</td><td class="tdTableDefinition">CONTACT_EMAIL</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
</table>
<div class="references">
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (CUSTOMER_ID)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>DATE_DIMENSION<a name="DATE_DIMENSION"></a>
</h1>
<h2>
      (Physical Name: DATE_DIMENSION)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DATE_ID (PK)</td><td class="tdTableDefinition">DATE_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DAY_DATE</td><td class="tdTableDefinition">DAY_DATE</td><td class="tdTableDefinition">DATE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DATESTRING_LONG</td><td class="tdTableDefinition">DATESTRING_LONG</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">WEEKDAY_NAME</td><td class="tdTableDefinition">WEEKDAY_NAME</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">MONTH_NAME</td><td class="tdTableDefinition">MONTH_NAME</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DATESTRING_ISO</td><td class="tdTableDefinition">DATESTRING_ISO</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DATESTRING_YYYYMMDD</td><td class="tdTableDefinition">DATESTRING_YYYYMMDD</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">WEEK_YYYYWW</td><td class="tdTableDefinition">WEEK_YYYYWW</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DAY_OF_MONTH</td><td class="tdTableDefinition">DAY_OF_MONTH</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DAY_OF_WEEK</td><td class="tdTableDefinition">DAY_OF_WEEK</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DAY_OF_YEAR</td><td class="tdTableDefinition">DAY_OF_YEAR</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">ISO_WEEK_OF_YEAR</td><td class="tdTableDefinition">ISO_WEEK_OF_YEAR</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">ISO_YEAR_OF_WEEK</td><td class="tdTableDefinition">ISO_YEAR_OF_WEEK</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">MONTH</td><td class="tdTableDefinition">MONTH</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">QUARTER</td><td class="tdTableDefinition">QUARTER</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">WEEK_OF_YEAR</td><td class="tdTableDefinition">WEEK_OF_YEAR</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">YEAR</td><td class="tdTableDefinition">YEAR</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">IS_WEEKEND</td><td class="tdTableDefinition">IS_WEEKEND</td><td class="tdTableDefinition">CHAR</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">HOLIDAY_NAME</td><td class="tdTableDefinition">HOLIDAY_NAME</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">IS_HOLIDAY</td><td class="tdTableDefinition">IS_HOLIDAY</td><td class="tdTableDefinition">CHAR</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">IS_FIXED_HOLIDAY</td><td class="tdTableDefinition">IS_FIXED_HOLIDAY</td><td class="tdTableDefinition">CHAR</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">IS_MOVABEL_HOLIDAY</td><td class="tdTableDefinition">IS_MOVABEL_HOLIDAY</td><td class="tdTableDefinition">CHAR</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
</table>
<div class="references">
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (DATE_ID)</li>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (DATE_ID)</li>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (DATE_ID)</li>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (DATE_ID)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>EMPLOYEE_DIMENSION<a name="EMPLOYEE_DIMENSION"></a>
</h1>
<h2>
      (Physical Name: EMPLOYEE_DIMENSION)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">EMPLOYEE_ID (PK)</td><td class="tdTableDefinition">EMPLOYEE_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_NUMBER</td><td class="tdTableDefinition">LOCATION_NUMBER</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_STREET</td><td class="tdTableDefinition">LOCATION_STREET</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_CITY</td><td class="tdTableDefinition">LOCATION_CITY</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_STATE</td><td class="tdTableDefinition">LOCATION_STATE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_POSTCODE</td><td class="tdTableDefinition">LOCATION_POSTCODE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_COUNTRY</td><td class="tdTableDefinition">LOCATION_COUNTRY</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_PHONE</td><td class="tdTableDefinition">CONTACT_PHONE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_FAX</td><td class="tdTableDefinition">CONTACT_FAX</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_EMAIL</td><td class="tdTableDefinition">CONTACT_EMAIL</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
</table>
<div class="references">
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (EMPLOYEE_ID)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>PRODUCT_DIMENSION<a name="PRODUCT_DIMENSION"></a>
</h1>
<h2>
      (Physical Name: PRODUCT_DIMENSION)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">PRODUCT_ID (PK)</td><td class="tdTableDefinition">PRODUCT_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">PRIMARY_VENDOR</td><td class="tdTableDefinition">PRIMARY_VENDOR</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CATEGORY_NAME</td><td class="tdTableDefinition">CATEGORY_NAME</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CATEGORY_DESCRIPTION</td><td class="tdTableDefinition">CATEGORY_DESCRIPTION</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">SUBCATEGORY_NAME</td><td class="tdTableDefinition">SUBCATEGORY_NAME</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">SUBCATEGORY_DESCRIPTION</td><td class="tdTableDefinition">SUBCATEGORY_DESCRIPTION</td><td class="tdTableDefinition">BLOB</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">WEIGHT</td><td class="tdTableDefinition">WEIGHT</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">WEIGHT_UNIT_OF_MEASURE</td><td class="tdTableDefinition">WEIGHT_UNIT_OF_MEASURE</td><td class="tdTableDefinition">VARCHAR(6)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">SIZE</td><td class="tdTableDefinition">SIZE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">SIZE_UNIT_OF_MEASURE</td><td class="tdTableDefinition">SIZE_UNIT_OF_MEASURE</td><td class="tdTableDefinition">VARCHAR(6)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">STANDART_UNIT_COST</td><td class="tdTableDefinition">STANDART_UNIT_COST</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">STANDART_UNIT_PRICE</td><td class="tdTableDefinition">STANDART_UNIT_PRICE</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
</table>
<div class="references">
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (PRODUCT_ID)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>PROMOTION_DIMENSION<a name="PROMOTION_DIMENSION"></a>
</h1>
<h2>
      (Physical Name: PROMOTION_DIMENSION)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">PROMOTION_ID (PK)</td><td class="tdTableDefinition">PROMOTION_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">START_DATE</td><td class="tdTableDefinition">START_DATE</td><td class="tdTableDefinition">DATE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">END_DATE</td><td class="tdTableDefinition">END_DATE</td><td class="tdTableDefinition">DATE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DISCOUNT_PORCENT</td><td class="tdTableDefinition">DISCOUNT_PORCENT</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
</table>
<div class="references">
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (PROMOTION_ID)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>SALES_FACT<a name="SALES_FACT"></a>
</h1>
<h2>
      (Physical Name: SALES_FACT)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">BRANCH_ID
                &nbsp;(<a href="#BRANCH_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">BRANCH_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">EMPLOYEE_ID
                &nbsp;(<a href="#EMPLOYEE_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">EMPLOYEE_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CUSTOMER_ID
                &nbsp;(<a href="#CUSTOMER_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">CUSTOMER_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">PROMOTION_ID
                &nbsp;(<a href="#PROMOTION_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">PROMOTION_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">SUPPLIER_ID
                &nbsp;(<a href="#SUPPLIER_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">SUPPLIER_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">PRODUCT_ID
                &nbsp;(<a href="#PRODUCT_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">PRODUCT_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">ORDER_DATE_ID
                &nbsp;(<a href="#DATE_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">ORDER_DATE_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">INVOICE_DATE_ID
                &nbsp;(<a href="#DATE_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">INVOICE_DATE_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">DELIVERY_DATE_ID
                &nbsp;(<a href="#DATE_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">DELIVERY_DATE_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CANCELLATION_DATE_ID
                &nbsp;(<a href="#DATE_DIMENSION">FK</a>)
              </td><td class="tdTableDefinition">CANCELLATION_DATE_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">UNIT_SALES</td><td class="tdTableDefinition">UNIT_SALES</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">UNIT_PRICE</td><td class="tdTableDefinition">UNIT_PRICE</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">UNIT_COST</td><td class="tdTableDefinition">UNIT_COST</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
</table>
<div class="references">
<p class="subTitle">References</p>
<ul>
<li>
<a href="#DATE_DIMENSION">DATE_DIMENSION</a> through (ORDER_DATE_ID)</li>
<li>
<a href="#DATE_DIMENSION">DATE_DIMENSION</a> through (INVOICE_DATE_ID)</li>
<li>
<a href="#DATE_DIMENSION">DATE_DIMENSION</a> through (DELIVERY_DATE_ID)</li>
<li>
<a href="#DATE_DIMENSION">DATE_DIMENSION</a> through (CANCELLATION_DATE_ID)</li>
<li>
<a href="#BRANCH_DIMENSION">BRANCH_DIMENSION</a> through (BRANCH_ID)</li>
<li>
<a href="#EMPLOYEE_DIMENSION">EMPLOYEE_DIMENSION</a> through (EMPLOYEE_ID)</li>
<li>
<a href="#CUSTOMER_DIMENSION">CUSTOMER_DIMENSION</a> through (CUSTOMER_ID)</li>
<li>
<a href="#PROMOTION_DIMENSION">PROMOTION_DIMENSION</a> through (PROMOTION_ID)</li>
<li>
<a href="#SUPPLIER_DIMENSION">SUPPLIER_DIMENSION</a> through (SUPPLIER_ID)</li>
<li>
<a href="#PRODUCT_DIMENSION">PRODUCT_DIMENSION</a> through (PRODUCT_ID)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>SUPPLIER_DIMENSION<a name="SUPPLIER_DIMENSION"></a>
</h1>
<h2>
      (Physical Name: SUPPLIER_DIMENSION)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">SUPPLIER_ID (PK)</td><td class="tdTableDefinition">SUPPLIER_ID</td><td class="tdTableDefinition">NUMERIC(18,0)</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">NAME</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_NUMBER</td><td class="tdTableDefinition">LOCATION_NUMBER</td><td class="tdTableDefinition">NUMERIC(6,0)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_STREET</td><td class="tdTableDefinition">LOCATION_STREET</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_CITY</td><td class="tdTableDefinition">LOCATION_CITY</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_STATE</td><td class="tdTableDefinition">LOCATION_STATE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_POST_CODE</td><td class="tdTableDefinition">LOCATION_POST_CODE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">LOCATION_COUNTRY</td><td class="tdTableDefinition">LOCATION_COUNTRY</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_PHONE</td><td class="tdTableDefinition">CONTACT_PHONE</td><td class="tdTableDefinition">VARCHAR(18)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_FAX</td><td class="tdTableDefinition">CONTACT_FAX</td><td class="tdTableDefinition">CHAR</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">CONTACT_EMAIL</td><td class="tdTableDefinition">CONTACT_EMAIL</td><td class="tdTableDefinition">VARCHAR(60)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
</table>
<div class="references">
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#SALES_FACT">SALES_FACT</a> referencing (SUPPLIER_ID)</li>
</ul>
</div>
</div>
</body>
</html>
